<%-- 
    Document   : email_text
    Created on : Apr 13, 2012, 11:41:19 AM
    Author     : dhananjay
--%>

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="jobportal.Dbconn"%>
<%@include file="header.jsp" %>

<table width="100%" border="0" cellspacing="0" cellpadding="0" style="padding-left:2px">

    <tr>
        <td align="center" valign="top" style="padding-left:2px"><script src="selectstate_sell.js"></script>

            <br />

            <table width="98%" border="0" cellpadding="0" cellspacing="0" align="left">
                <tbody>
                    <tr>
                        <td align="left" class="blueheadbd">Employer  - Email Messages
                        </td>
                    </tr>
                    <tr>
                        <td height="15" align="left">&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="15" align="left"><table style="border: 1px solid rgb(169, 211, 225);" border="0" cellpadding="0" cellspacing="0" width="100%">
                                <tbody>
                                    <tr><%
                                        try {
                                                    Connection con = Dbconn.getConn();
                                                    Statement st = con.createStatement();
                                                    ResultSet rs=st.executeQuery("select * from emailmessage where user='emp'");
                                                    rs.last();
                                                    %>
                                        <td height="22" colspan="4" align="left" valign="middle" class="bluebg"><span class="canhead"><b>&nbsp;&nbsp;Email Messages ( <%=rs.getRow()%> )  <span class="tablebackground">

                                                    </span></b></span></td>
                                    </tr>
                                    <tr>
                                        <td height="1" colspan="4" class="bluebord"><img src="../images/blank.gif" alt="" border="0" height="1" width="1" /></td>          </tr>
                                    <tr>
                                        <td width="12">&nbsp;</td>
                                        <td width="58" align="right" valign="top" style="padding-top: 5px;">&nbsp;</td>
                                        <td width="345" align="left" valign="top" style="padding-top:5px"><strong>Email Name</strong> </td>
                                        <td width="789" align="left" valign="top" style="padding-top:5px"><strong>Action</strong></td>
                                    </tr>
                                    <%
                                                rs=st.executeQuery("select * from emailmessage where user='emp'");
                                                    while(rs.next()){
                                    %>
                                    <tr>
                                        <td>&nbsp;</td>
                                        <td align="center" valign="top" style="padding-top: 5px;"><%=rs.getRow()%></td>
                                        <td align="left" valign="top" style="padding-top:5px"><a href="edit_email_message.jsp?emailid=<%=rs.getString("id")%>&page=emailtext_emp.jsp"><%=rs.getString("subject")%></a></td>
                                        <td align="left" valign="top" style="padding-top:5px"><a href="edit_email_message.jsp?emailid=<%=rs.getString("id")%>&page=emailtext_emp.jsp">Edit</a></td>
                                    </tr>
                                    <%
                                           } }catch(Exception e){}

                                    %>
                                    <tr>
                                        <td colspan="4"><img src="../images/blank.gif" alt="" border="0" height="6" width="1" /></td>          </tr>
                                </tbody>
                            </table></td>
                    </tr>
                    <tr>
                        <td height="15" align="left" valign="top">&nbsp;</td>
                    </tr>
                    <tr>
                        <td height="15" align="left"></td>
                    </tr>
                </tbody>
            </table>

        </td>
    </tr>
    <tr>
        <td height="337" colspan="2">&nbsp;</td>
    </tr>
    <tr>
        <td colspan="2"><style type="text/css">
        <!--
        .style1 {font-size: xx-small}
        -->
    </style>
    <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tbody><tr><td><DIV class="GrayTxt SmFont PadFive" align=right><span class="style1"></span><BR>
                    </DIV>
                </td></tr>
            <tr>
                <td>&nbsp;</td>
            </tr>
        </tbody></table>
    
    <%@include file="footer.jsp" %>